class CreatePlayers < ActiveRecord::Migration
  def self.up
    create_table :players do |t|
      t.column :email, :string
      t.column :password, :string
      t.column :first_name, :string
      t.column :last_name, :string
      t.column :faculty, :string
      t.column :year, :integer
      t.column :alias, :string
      t.column :active, :boolean
      t.column :activation_hash, :string
      t.column :picture_confirmation, :boolean
      t.column :parent_id,  :integer
      t.column :content_type, :string
      t.column :filename, :string    
      t.column :thumbnail, :string 
      t.column :size, :integer
      t.column :width, :integer
      t.column :height, :integer
    end
  end

  def self.down
    drop_table :players
  end
end
